OPTIONS(direct=true,silent=feedback)
LOAD DATA
CHARACTERSET UTF8
INFILE 'stg_position_service_usage_rd.txt'
INTO TABLE stg_position_service_usage_rd
TRUNCATE
FIELDS TERMINATED BY X'09'
(date_id "substr(:date_id,1,4)||substr(:date_id,6,2)||substr(:date_id,9,2)",
hour,
operator_id,
serving_mcc,
serving_mnc,
mcc_country,
network_type_id,
platform_type_id,
protocol_type_id,
um_mcc,
um_mnc,
um_lac_rnc_tac_rz,
um_enb,
um_cellid_baseid,
um_neighbor_cell,
um_wlan,
um_ref_loc,
um_wlan_neighbor_cell,
um_wlan_cellid_baseid,
client_name,
um_mcc_count, 
um_mnc_count, 
um_lac_rnc_tac_rz_count, 
um_enb_count, 
um_cellid_baseid_count,
um_neighbor_cell_count,
um_wlan_count,
um_ref_loc_count,
um_wlan_neighbor_cell_count,
um_wlan_cellid_baseid_count,
pm_wlan_count,
pm_wlan_cellular_count,
pm_cellular_count,
hr2_0_100,
hr2_100_250,
hr2_250_500,
hr2_500_2000,
hr2_2000_infinity,
hr0_100,
hr100_200,
hr200_250,
hr250_300,
hr300_400,
hr400_500,
hr500_600,
hr600_700,
hr700_800,
hr800_900,
hr900_1000,
hr1000_1100,
hr1100_1200,
hr1200_1300,
hr1300_1400,
hr1400_1500,
hr1500_1600,
hr1600_1700,
hr1700_1800,
hr1800_1900,
hr1900_2000,
hr2000_2100,
hr2100_2200,
hr2200_2300,
hr2300_2400,
hr2400_2500,
hr2500_2600,
hr2600_2700,
hr2700_2800,
hr2800_2900,
hr2900_3000,
hr3000_infinity,
haccuracy_median,
haccuracy_percentile,
haccuracy_median_weight,
haccuracy_percentile_weight,
haccuracy_count,
success_count,
total_count)
